Tata Infotech Previous Years Solved Sample Placement Papers

1. Choose the correct alternative regarding the following statements about Java:
   a) It is compiled using javac compiler.
   b) The compiled files have .class extension.
   c) Such files cannot be transferred from one computer to another.
   d) They use the Java interpreter.
   

   A. True

   B. True

   C. False Answer: Option C

   D. True

2. Solution: Java files with .class extension can be transferred across systems, making option C incorrect.
3. Why is synchronize used?
   a) To initialize multiple objects
   b) To lock an object
   c) Option 3
   d) Option 4
   

   A. No

   B. Yes Answer: Option B

4. Solution: Synchronize is used to lock an object to prevent concurrent access issues.
5. Piggybacking is a technique for:
   a) Flow control
   b) Sequence
   c) Acknowledgement
   d) Retransmission
   

   A. No

   B. No

   C. Yes Answer: Option C

   D. No

6. Solution: Piggybacking is used for sending acknowledgments along with data to optimize communication.
7. The layer in the OSI model that handles terminal emulation:
   a) Session
   b) Application
   c) Presentation
   d) Transport
   

   A. No

   B. Yes Answer: Option B

   C. No

   D. No

8. Solution: The application layer provides terminal emulation functionalities.
9. In signed magnitude notation, what is the minimum value that can be represented with 8 bits?
   a) -128
   b) -255
   c) -127
   d) 0
   
10. Solution: The minimum value depends on the representation; for signed magnitude, it is generally -127.
11. There is an employer table with key fields as employer no. Data in every nth row is needed for a simple query. Which query will get the required results?
    a) SELECT A.employer_no FROM employer A WHERE EXISTS (SELECT * FROM employer B WHERE A.employer_no >= B.employer_no HAVING (COUNT(*) MOD n) = 0)
    b) SELECT employer_no FROM employer A, employer B WHERE A.employer_no >= B.employer_no GROUP BY employer_no HAVING (COUNT(*) MOD n) = 0
    c) Both a & b
    d) None of the above
    

    A. No

    B. No

    C. Yes Answer: Option C

    D. No

12. Solution: Both queries satisfy the condition to retrieve the required rows.
13. To delete duplicates of a row in a table 'customer' with non-uniform key field 'customer_no', you can:
    a) DELETE FROM customer WHERE customer_no EXISTS (SELECT DISTINCT customer_no FROM customer HAVING COUNT(*) > 1)
    b) DELETE customer A WHERE customer_no IN B.rowid
    c) DELETE customer A WHERE customer_no IN (SELECT customer_no FROM customer A, customer B)
    d) None of the above
    

    A. No

    B. No

    C. No

    D. Yes Answer: Option D

14. Solution: None of the given options accurately handle duplicate deletion in the specified case.